Student Solution

-->

"Education is the most powerful weapon which you can use to change the world”
– Nelson Mandela

1 University

1 Course

4 Subjects

Week 3 Data Management Project

Week 3 Data Management Project

Q The Data Management Project for week 3 builds upon what you did for the Data Management Project in weeks 1 and 2. Create a logical data model of data management project showing the entities, relationships, primary keys, and foreign keys. Eliminate composite attributes, like student_name, by creating student_first_name and student_last_name. Create associative entities to resolve any many-to-many relationships between entities. Make sure each entity is in third normal form, meaning that each non-key attribute must depend on the primary key, the whole primary key, and only nothing but the primary key. Use the Diagrams.net (formerly draw.io) tool (https://app.diagrams.net/) to create your logical model. Export your data model as a PDF and save it on your PC, as shown in theDraw.io video tutorialLinks to an external site. . Submit the PDF via the assignment link. Resources: • Textbook: Module 6 – Normalization of Data Tables • Video: Module 6 – Normalization of Data Tables (10:44 min.) • Video: Module 6 – Improving the Design (8:34 min.) • PowerPoint: Module 6 Review charts Rubric Data Management Final Project Weekly Submission Rubric Data Management Final Project Weekly Submission Rubric Criteria Ratings Pts This criterion is linked to a Learning OutcomeCritical Thinking 20 pts Main points are concise, clear and well developed. Evidence and detail provide superior support for the assignment. 18 pts Main points are clear and well developed. Evidence and detail provide strong support for the assignment. 16 pts Main points are clear and developed. Evidence and detail adequately support the assignment. 14 pts Presents an incomplete analysis of the issues identified and demonstrates an inadequate understanding of the topic(s) and issue(s). 20 pts This criterion is linked to a Learning OutcomeAnalysis 20 pts Makes appropriate and powerful connections between the issues identified and the strategic concepts studied in the reading; Demonstrates complete command of the strategic concepts and analytical tools studied. Supports diagnosis and opinions with strong arguments and evidence; presents a balanced and critical view; interpretation is both reasonable and objective. 18 pts Makes appropriate connections between the issues identified and the strategic concepts studied in the reading; Demonstrates good command of the strategic concepts and analytical tools studied. Supports diagnosis and opinions with reasons and evidence; presents a fairly balanced view; interpretation is both reasonable and objective. 16 pts Makes appropriate but somewhat vague connections between the issues and concepts studied in the reading; Demonstrates limited command of the strategic concepts and analytical tools studied. Supports diagnosis and opinions with limited reasons and evidence; presents a somewhat one-sided argument. 14 pts Makes little or no connection between the issues identified and the strategic concepts studied in the reading. Supports diagnosis and opinions with few reasons and little evidence; argument is one-sided and not objective. 20 pts This criterion is linked to a Learning OutcomeKnowledge of Content 20 pts Exceeds requirements in demonstrating strong knowledge of content and depth. 18 pts Knowledge of content and depth are appropriately reflected in the assignment 16 pts Supplements case study with limited research into the present situation of the company; provides limited documentation of sources consulted. 14 pts Some knowledge of content and depth are evident. 20 pts This criterion is linked to a Learning OutcomeAssignment Requirements 20 pts Presents detailed, realistic, and appropriate recommendations clearly supported by the requirements for the weekly submission. 18 pts Work is accurately detailed. The weekly assignment requirements are adequately addressed. 16 pts Work reflects the assignment requirements. The weekly assignment requirements are somewhat addressed. 14 pts Work rarely reflects the assignment requirements. The weekly assignment requirements are rarely addressed. 20 pts This criterion is linked to a Learning OutcomeWriting Mechanics 20 pts Writing demonstrates a sophisticated clarity, conciseness, and correctness; includes thorough details and relevant data and information; extremely well-organized. 18 pts Writing is accomplished in terms of clarity and conciseness and contains only a few errors; includes sufficient details and relevant data and information; well-organized. 16 pts Knowledge of content and depth are satisfactory. 14 pts Writing is unfocused, rambling, or contains serious errors; lacks detail and relevant data and information. 20 pts Total Points: 100

View Related Questions

Solution Preview

Employee PK EmployeeID EmployeeFirstName EmployeeLastName Customer PK CustomerID CustomerFirstName CustomerLastName